outer join

Therefore, a SORT node is also added to the outer of the join to enforce the order.

因此，也要添加SORT节点到联接的外部来执行顺序。

the developer used outer join fetching in the query.

这位开发人员在查询中使用了外连接抓取。

the teacher used a left outer join to combine the tables.

老师使用了左外连接来合并表格。

the teacher explained the natural left outer join in the sql lesson.

老师在SQL课上讲解了自然左外连接。

the tables or views in the from clause can be specified in any order with an inner join or full outer join.

FROM子句中的表或视图可通过内部联接或完整外部联接按任意顺序指定。

both terms of an outer join must contain columns.

外联接的两项都必须包含列。

you join two tables by using an inner join or an outer join.

可以通过使用内连接或外连接来连接两个表。

the teacher explained the right outer join in the database lesson.

老师在数据库课上讲解了右外连接。

the teacher explained the asymmetrical outer join in class.

老师在课堂上讲解了非对称外连接。

In these cases, keep in mind that the local processing of a full outer join may also impact performance.

这种情况下，请记住，完全外连接的本地化处理也会影响性能。

outer join operators cannot be specified in a query containing joined tables.

在包含已联接的表的查询中，不能指定外联接操作符。

There is also a full outer join between these two sub queries based on a column called sc.

在基于名为sc的列上还有两个子查询的完全外连接。

for example, the following select statement does a left outer join on these two tables

例如，下面的SELECT语句对这两个表进行左向外部联接

leo used a group outer join in his sql query.

利奥在他的SQL查询中使用了全外连接。

the merge statement first does a join ( outer join or inner join, depending on the merge statement) between source and target table rows.

merge语句首先进行（外部联接或者内部联接，取决于merge语句）源与目标表行之间的联接。

the developer used an outer join fetch in the query.

开发人员在查询中使用了外连接抓取。

when performing an outer join on a pair of tables while also retrieving data from a third table, specify the tables used for the outer join adjacent to the join keywords in db2.

当对两个表执行外部连接并从第三个表检索数据时，要在DB2中设置外部连接中连接到join关键字的表。

the database uses a partitioned outer join to combine the data.

数据库使用分区外连接来合并数据。

the teacher explained the left outer join in the database class.

老师在数据库课上讲解了左外连接。

a right outer join is the reverse of a left outer join.

右向外部联接是左向外部联接的反向联接。

All rows from both tables are returned in a full outer join.

在完全外部联接中，将返回两个表的所有行。

change an inner join to an outer join

将内部联接更改为外部联接

only two tables are allowed with an outer join. delete outer join to add table?

外部连接只允许两个表。是否要删除外部连接以添加表？

however, the order of tables or views specified when using either a left or right outer join is important.

但是，用左向或右向外部联接时，指定表或视图的顺序很重要。

This query performs an outer join to compare the sales information for10 particular stores for January and November.

这个查询会执行一个外连接操作，以便比较从1月份至11月份的10个特殊商店的销售信息。

the fact that this is also called an inner join might also indicate that an alternative called outer join exists.

这也被称为INNERJOIN，这一事实也表明有另一种称作OUTERJOIN的类型存在。

the developer used a left outer join fetch in the query.

开发人员在查询中使用了左外连接获取。

note that the join being performed is an outer join.

注意，所执行的联接是个外部联接。

noah learned the outer join operation in his computer class.

诺亚在他的计算机课上学习了外连接操作。

To retain the nonmatching information by including nonmatching rows in the results of a join, use a full outer join.

若要通过在联接的结果中包括不匹配的行来保留不匹配信息，请使用完全外部联接。